package com.dk.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class QcIqcExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public QcIqcExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIqcIdIsNull() {
            addCriterion("iqc_id is null");
            return (Criteria) this;
        }

        public Criteria andIqcIdIsNotNull() {
            addCriterion("iqc_id is not null");
            return (Criteria) this;
        }

        public Criteria andIqcIdEqualTo(Long value) {
            addCriterion("iqc_id =", value, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdNotEqualTo(Long value) {
            addCriterion("iqc_id <>", value, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdGreaterThan(Long value) {
            addCriterion("iqc_id >", value, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdGreaterThanOrEqualTo(Long value) {
            addCriterion("iqc_id >=", value, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdLessThan(Long value) {
            addCriterion("iqc_id <", value, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdLessThanOrEqualTo(Long value) {
            addCriterion("iqc_id <=", value, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdIn(List<Long> values) {
            addCriterion("iqc_id in", values, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdNotIn(List<Long> values) {
            addCriterion("iqc_id not in", values, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdBetween(Long value1, Long value2) {
            addCriterion("iqc_id between", value1, value2, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcIdNotBetween(Long value1, Long value2) {
            addCriterion("iqc_id not between", value1, value2, "iqcId");
            return (Criteria) this;
        }

        public Criteria andIqcCodeIsNull() {
            addCriterion("iqc_code is null");
            return (Criteria) this;
        }

        public Criteria andIqcCodeIsNotNull() {
            addCriterion("iqc_code is not null");
            return (Criteria) this;
        }

        public Criteria andIqcCodeEqualTo(String value) {
            addCriterion("iqc_code =", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeNotEqualTo(String value) {
            addCriterion("iqc_code <>", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeGreaterThan(String value) {
            addCriterion("iqc_code >", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeGreaterThanOrEqualTo(String value) {
            addCriterion("iqc_code >=", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeLessThan(String value) {
            addCriterion("iqc_code <", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeLessThanOrEqualTo(String value) {
            addCriterion("iqc_code <=", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeLike(String value) {
            addCriterion("iqc_code like", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeNotLike(String value) {
            addCriterion("iqc_code not like", value, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeIn(List<String> values) {
            addCriterion("iqc_code in", values, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeNotIn(List<String> values) {
            addCriterion("iqc_code not in", values, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeBetween(String value1, String value2) {
            addCriterion("iqc_code between", value1, value2, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcCodeNotBetween(String value1, String value2) {
            addCriterion("iqc_code not between", value1, value2, "iqcCode");
            return (Criteria) this;
        }

        public Criteria andIqcNameIsNull() {
            addCriterion("iqc_name is null");
            return (Criteria) this;
        }

        public Criteria andIqcNameIsNotNull() {
            addCriterion("iqc_name is not null");
            return (Criteria) this;
        }

        public Criteria andIqcNameEqualTo(String value) {
            addCriterion("iqc_name =", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameNotEqualTo(String value) {
            addCriterion("iqc_name <>", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameGreaterThan(String value) {
            addCriterion("iqc_name >", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameGreaterThanOrEqualTo(String value) {
            addCriterion("iqc_name >=", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameLessThan(String value) {
            addCriterion("iqc_name <", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameLessThanOrEqualTo(String value) {
            addCriterion("iqc_name <=", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameLike(String value) {
            addCriterion("iqc_name like", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameNotLike(String value) {
            addCriterion("iqc_name not like", value, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameIn(List<String> values) {
            addCriterion("iqc_name in", values, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameNotIn(List<String> values) {
            addCriterion("iqc_name not in", values, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameBetween(String value1, String value2) {
            addCriterion("iqc_name between", value1, value2, "iqcName");
            return (Criteria) this;
        }

        public Criteria andIqcNameNotBetween(String value1, String value2) {
            addCriterion("iqc_name not between", value1, value2, "iqcName");
            return (Criteria) this;
        }

        public Criteria andTemplateIdIsNull() {
            addCriterion("template_id is null");
            return (Criteria) this;
        }

        public Criteria andTemplateIdIsNotNull() {
            addCriterion("template_id is not null");
            return (Criteria) this;
        }

        public Criteria andTemplateIdEqualTo(Long value) {
            addCriterion("template_id =", value, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdNotEqualTo(Long value) {
            addCriterion("template_id <>", value, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdGreaterThan(Long value) {
            addCriterion("template_id >", value, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdGreaterThanOrEqualTo(Long value) {
            addCriterion("template_id >=", value, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdLessThan(Long value) {
            addCriterion("template_id <", value, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdLessThanOrEqualTo(Long value) {
            addCriterion("template_id <=", value, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdIn(List<Long> values) {
            addCriterion("template_id in", values, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdNotIn(List<Long> values) {
            addCriterion("template_id not in", values, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdBetween(Long value1, Long value2) {
            addCriterion("template_id between", value1, value2, "templateId");
            return (Criteria) this;
        }

        public Criteria andTemplateIdNotBetween(Long value1, Long value2) {
            addCriterion("template_id not between", value1, value2, "templateId");
            return (Criteria) this;
        }

        public Criteria andVendorIdIsNull() {
            addCriterion("vendor_id is null");
            return (Criteria) this;
        }

        public Criteria andVendorIdIsNotNull() {
            addCriterion("vendor_id is not null");
            return (Criteria) this;
        }

        public Criteria andVendorIdEqualTo(Long value) {
            addCriterion("vendor_id =", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdNotEqualTo(Long value) {
            addCriterion("vendor_id <>", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdGreaterThan(Long value) {
            addCriterion("vendor_id >", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vendor_id >=", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdLessThan(Long value) {
            addCriterion("vendor_id <", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdLessThanOrEqualTo(Long value) {
            addCriterion("vendor_id <=", value, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdIn(List<Long> values) {
            addCriterion("vendor_id in", values, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdNotIn(List<Long> values) {
            addCriterion("vendor_id not in", values, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdBetween(Long value1, Long value2) {
            addCriterion("vendor_id between", value1, value2, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorIdNotBetween(Long value1, Long value2) {
            addCriterion("vendor_id not between", value1, value2, "vendorId");
            return (Criteria) this;
        }

        public Criteria andVendorCodeIsNull() {
            addCriterion("vendor_code is null");
            return (Criteria) this;
        }

        public Criteria andVendorCodeIsNotNull() {
            addCriterion("vendor_code is not null");
            return (Criteria) this;
        }

        public Criteria andVendorCodeEqualTo(String value) {
            addCriterion("vendor_code =", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeNotEqualTo(String value) {
            addCriterion("vendor_code <>", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeGreaterThan(String value) {
            addCriterion("vendor_code >", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vendor_code >=", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeLessThan(String value) {
            addCriterion("vendor_code <", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeLessThanOrEqualTo(String value) {
            addCriterion("vendor_code <=", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeLike(String value) {
            addCriterion("vendor_code like", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeNotLike(String value) {
            addCriterion("vendor_code not like", value, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeIn(List<String> values) {
            addCriterion("vendor_code in", values, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeNotIn(List<String> values) {
            addCriterion("vendor_code not in", values, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeBetween(String value1, String value2) {
            addCriterion("vendor_code between", value1, value2, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorCodeNotBetween(String value1, String value2) {
            addCriterion("vendor_code not between", value1, value2, "vendorCode");
            return (Criteria) this;
        }

        public Criteria andVendorNameIsNull() {
            addCriterion("vendor_name is null");
            return (Criteria) this;
        }

        public Criteria andVendorNameIsNotNull() {
            addCriterion("vendor_name is not null");
            return (Criteria) this;
        }

        public Criteria andVendorNameEqualTo(String value) {
            addCriterion("vendor_name =", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameNotEqualTo(String value) {
            addCriterion("vendor_name <>", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameGreaterThan(String value) {
            addCriterion("vendor_name >", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameGreaterThanOrEqualTo(String value) {
            addCriterion("vendor_name >=", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameLessThan(String value) {
            addCriterion("vendor_name <", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameLessThanOrEqualTo(String value) {
            addCriterion("vendor_name <=", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameLike(String value) {
            addCriterion("vendor_name like", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameNotLike(String value) {
            addCriterion("vendor_name not like", value, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameIn(List<String> values) {
            addCriterion("vendor_name in", values, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameNotIn(List<String> values) {
            addCriterion("vendor_name not in", values, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameBetween(String value1, String value2) {
            addCriterion("vendor_name between", value1, value2, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNameNotBetween(String value1, String value2) {
            addCriterion("vendor_name not between", value1, value2, "vendorName");
            return (Criteria) this;
        }

        public Criteria andVendorNickIsNull() {
            addCriterion("vendor_nick is null");
            return (Criteria) this;
        }

        public Criteria andVendorNickIsNotNull() {
            addCriterion("vendor_nick is not null");
            return (Criteria) this;
        }

        public Criteria andVendorNickEqualTo(String value) {
            addCriterion("vendor_nick =", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickNotEqualTo(String value) {
            addCriterion("vendor_nick <>", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickGreaterThan(String value) {
            addCriterion("vendor_nick >", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickGreaterThanOrEqualTo(String value) {
            addCriterion("vendor_nick >=", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickLessThan(String value) {
            addCriterion("vendor_nick <", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickLessThanOrEqualTo(String value) {
            addCriterion("vendor_nick <=", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickLike(String value) {
            addCriterion("vendor_nick like", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickNotLike(String value) {
            addCriterion("vendor_nick not like", value, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickIn(List<String> values) {
            addCriterion("vendor_nick in", values, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickNotIn(List<String> values) {
            addCriterion("vendor_nick not in", values, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickBetween(String value1, String value2) {
            addCriterion("vendor_nick between", value1, value2, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorNickNotBetween(String value1, String value2) {
            addCriterion("vendor_nick not between", value1, value2, "vendorNick");
            return (Criteria) this;
        }

        public Criteria andVendorBatchIsNull() {
            addCriterion("vendor_batch is null");
            return (Criteria) this;
        }

        public Criteria andVendorBatchIsNotNull() {
            addCriterion("vendor_batch is not null");
            return (Criteria) this;
        }

        public Criteria andVendorBatchEqualTo(String value) {
            addCriterion("vendor_batch =", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchNotEqualTo(String value) {
            addCriterion("vendor_batch <>", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchGreaterThan(String value) {
            addCriterion("vendor_batch >", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchGreaterThanOrEqualTo(String value) {
            addCriterion("vendor_batch >=", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchLessThan(String value) {
            addCriterion("vendor_batch <", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchLessThanOrEqualTo(String value) {
            addCriterion("vendor_batch <=", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchLike(String value) {
            addCriterion("vendor_batch like", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchNotLike(String value) {
            addCriterion("vendor_batch not like", value, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchIn(List<String> values) {
            addCriterion("vendor_batch in", values, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchNotIn(List<String> values) {
            addCriterion("vendor_batch not in", values, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchBetween(String value1, String value2) {
            addCriterion("vendor_batch between", value1, value2, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andVendorBatchNotBetween(String value1, String value2) {
            addCriterion("vendor_batch not between", value1, value2, "vendorBatch");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNull() {
            addCriterion("item_id is null");
            return (Criteria) this;
        }

        public Criteria andItemIdIsNotNull() {
            addCriterion("item_id is not null");
            return (Criteria) this;
        }

        public Criteria andItemIdEqualTo(Long value) {
            addCriterion("item_id =", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotEqualTo(Long value) {
            addCriterion("item_id <>", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThan(Long value) {
            addCriterion("item_id >", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdGreaterThanOrEqualTo(Long value) {
            addCriterion("item_id >=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThan(Long value) {
            addCriterion("item_id <", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdLessThanOrEqualTo(Long value) {
            addCriterion("item_id <=", value, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdIn(List<Long> values) {
            addCriterion("item_id in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotIn(List<Long> values) {
            addCriterion("item_id not in", values, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdBetween(Long value1, Long value2) {
            addCriterion("item_id between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemIdNotBetween(Long value1, Long value2) {
            addCriterion("item_id not between", value1, value2, "itemId");
            return (Criteria) this;
        }

        public Criteria andItemCodeIsNull() {
            addCriterion("item_code is null");
            return (Criteria) this;
        }

        public Criteria andItemCodeIsNotNull() {
            addCriterion("item_code is not null");
            return (Criteria) this;
        }

        public Criteria andItemCodeEqualTo(String value) {
            addCriterion("item_code =", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotEqualTo(String value) {
            addCriterion("item_code <>", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeGreaterThan(String value) {
            addCriterion("item_code >", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeGreaterThanOrEqualTo(String value) {
            addCriterion("item_code >=", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeLessThan(String value) {
            addCriterion("item_code <", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeLessThanOrEqualTo(String value) {
            addCriterion("item_code <=", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeLike(String value) {
            addCriterion("item_code like", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotLike(String value) {
            addCriterion("item_code not like", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeIn(List<String> values) {
            addCriterion("item_code in", values, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotIn(List<String> values) {
            addCriterion("item_code not in", values, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeBetween(String value1, String value2) {
            addCriterion("item_code between", value1, value2, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotBetween(String value1, String value2) {
            addCriterion("item_code not between", value1, value2, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemNameIsNull() {
            addCriterion("item_name is null");
            return (Criteria) this;
        }

        public Criteria andItemNameIsNotNull() {
            addCriterion("item_name is not null");
            return (Criteria) this;
        }

        public Criteria andItemNameEqualTo(String value) {
            addCriterion("item_name =", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotEqualTo(String value) {
            addCriterion("item_name <>", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameGreaterThan(String value) {
            addCriterion("item_name >", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameGreaterThanOrEqualTo(String value) {
            addCriterion("item_name >=", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameLessThan(String value) {
            addCriterion("item_name <", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameLessThanOrEqualTo(String value) {
            addCriterion("item_name <=", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameLike(String value) {
            addCriterion("item_name like", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotLike(String value) {
            addCriterion("item_name not like", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameIn(List<String> values) {
            addCriterion("item_name in", values, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotIn(List<String> values) {
            addCriterion("item_name not in", values, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameBetween(String value1, String value2) {
            addCriterion("item_name between", value1, value2, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotBetween(String value1, String value2) {
            addCriterion("item_name not between", value1, value2, "itemName");
            return (Criteria) this;
        }

        public Criteria andSpecificationIsNull() {
            addCriterion("specification is null");
            return (Criteria) this;
        }

        public Criteria andSpecificationIsNotNull() {
            addCriterion("specification is not null");
            return (Criteria) this;
        }

        public Criteria andSpecificationEqualTo(String value) {
            addCriterion("specification =", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationNotEqualTo(String value) {
            addCriterion("specification <>", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationGreaterThan(String value) {
            addCriterion("specification >", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationGreaterThanOrEqualTo(String value) {
            addCriterion("specification >=", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationLessThan(String value) {
            addCriterion("specification <", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationLessThanOrEqualTo(String value) {
            addCriterion("specification <=", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationLike(String value) {
            addCriterion("specification like", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationNotLike(String value) {
            addCriterion("specification not like", value, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationIn(List<String> values) {
            addCriterion("specification in", values, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationNotIn(List<String> values) {
            addCriterion("specification not in", values, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationBetween(String value1, String value2) {
            addCriterion("specification between", value1, value2, "specification");
            return (Criteria) this;
        }

        public Criteria andSpecificationNotBetween(String value1, String value2) {
            addCriterion("specification not between", value1, value2, "specification");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureIsNull() {
            addCriterion("unit_of_measure is null");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureIsNotNull() {
            addCriterion("unit_of_measure is not null");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureEqualTo(String value) {
            addCriterion("unit_of_measure =", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureNotEqualTo(String value) {
            addCriterion("unit_of_measure <>", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureGreaterThan(String value) {
            addCriterion("unit_of_measure >", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureGreaterThanOrEqualTo(String value) {
            addCriterion("unit_of_measure >=", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureLessThan(String value) {
            addCriterion("unit_of_measure <", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureLessThanOrEqualTo(String value) {
            addCriterion("unit_of_measure <=", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureLike(String value) {
            addCriterion("unit_of_measure like", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureNotLike(String value) {
            addCriterion("unit_of_measure not like", value, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureIn(List<String> values) {
            addCriterion("unit_of_measure in", values, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureNotIn(List<String> values) {
            addCriterion("unit_of_measure not in", values, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureBetween(String value1, String value2) {
            addCriterion("unit_of_measure between", value1, value2, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andUnitOfMeasureNotBetween(String value1, String value2) {
            addCriterion("unit_of_measure not between", value1, value2, "unitOfMeasure");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckIsNull() {
            addCriterion("quantity_min_check is null");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckIsNotNull() {
            addCriterion("quantity_min_check is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckEqualTo(Integer value) {
            addCriterion("quantity_min_check =", value, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckNotEqualTo(Integer value) {
            addCriterion("quantity_min_check <>", value, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckGreaterThan(Integer value) {
            addCriterion("quantity_min_check >", value, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_min_check >=", value, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckLessThan(Integer value) {
            addCriterion("quantity_min_check <", value, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_min_check <=", value, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckIn(List<Integer> values) {
            addCriterion("quantity_min_check in", values, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckNotIn(List<Integer> values) {
            addCriterion("quantity_min_check not in", values, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckBetween(Integer value1, Integer value2) {
            addCriterion("quantity_min_check between", value1, value2, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMinCheckNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_min_check not between", value1, value2, "quantityMinCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedIsNull() {
            addCriterion("quantity_max_unqualified is null");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedIsNotNull() {
            addCriterion("quantity_max_unqualified is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedEqualTo(Integer value) {
            addCriterion("quantity_max_unqualified =", value, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedNotEqualTo(Integer value) {
            addCriterion("quantity_max_unqualified <>", value, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedGreaterThan(Integer value) {
            addCriterion("quantity_max_unqualified >", value, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_max_unqualified >=", value, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedLessThan(Integer value) {
            addCriterion("quantity_max_unqualified <", value, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_max_unqualified <=", value, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedIn(List<Integer> values) {
            addCriterion("quantity_max_unqualified in", values, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedNotIn(List<Integer> values) {
            addCriterion("quantity_max_unqualified not in", values, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedBetween(Integer value1, Integer value2) {
            addCriterion("quantity_max_unqualified between", value1, value2, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityMaxUnqualifiedNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_max_unqualified not between", value1, value2, "quantityMaxUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedIsNull() {
            addCriterion("quantity_recived is null");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedIsNotNull() {
            addCriterion("quantity_recived is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedEqualTo(Double value) {
            addCriterion("quantity_recived =", value, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedNotEqualTo(Double value) {
            addCriterion("quantity_recived <>", value, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedGreaterThan(Double value) {
            addCriterion("quantity_recived >", value, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedGreaterThanOrEqualTo(Double value) {
            addCriterion("quantity_recived >=", value, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedLessThan(Double value) {
            addCriterion("quantity_recived <", value, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedLessThanOrEqualTo(Double value) {
            addCriterion("quantity_recived <=", value, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedIn(List<Double> values) {
            addCriterion("quantity_recived in", values, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedNotIn(List<Double> values) {
            addCriterion("quantity_recived not in", values, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedBetween(Double value1, Double value2) {
            addCriterion("quantity_recived between", value1, value2, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityRecivedNotBetween(Double value1, Double value2) {
            addCriterion("quantity_recived not between", value1, value2, "quantityRecived");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckIsNull() {
            addCriterion("quantity_check is null");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckIsNotNull() {
            addCriterion("quantity_check is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckEqualTo(Integer value) {
            addCriterion("quantity_check =", value, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckNotEqualTo(Integer value) {
            addCriterion("quantity_check <>", value, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckGreaterThan(Integer value) {
            addCriterion("quantity_check >", value, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_check >=", value, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckLessThan(Integer value) {
            addCriterion("quantity_check <", value, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_check <=", value, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckIn(List<Integer> values) {
            addCriterion("quantity_check in", values, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckNotIn(List<Integer> values) {
            addCriterion("quantity_check not in", values, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckBetween(Integer value1, Integer value2) {
            addCriterion("quantity_check between", value1, value2, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityCheckNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_check not between", value1, value2, "quantityCheck");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedIsNull() {
            addCriterion("quantity_unqualified is null");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedIsNotNull() {
            addCriterion("quantity_unqualified is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedEqualTo(Integer value) {
            addCriterion("quantity_unqualified =", value, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedNotEqualTo(Integer value) {
            addCriterion("quantity_unqualified <>", value, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedGreaterThan(Integer value) {
            addCriterion("quantity_unqualified >", value, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_unqualified >=", value, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedLessThan(Integer value) {
            addCriterion("quantity_unqualified <", value, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_unqualified <=", value, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedIn(List<Integer> values) {
            addCriterion("quantity_unqualified in", values, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedNotIn(List<Integer> values) {
            addCriterion("quantity_unqualified not in", values, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedBetween(Integer value1, Integer value2) {
            addCriterion("quantity_unqualified between", value1, value2, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andQuantityUnqualifiedNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_unqualified not between", value1, value2, "quantityUnqualified");
            return (Criteria) this;
        }

        public Criteria andCrRateIsNull() {
            addCriterion("cr_rate is null");
            return (Criteria) this;
        }

        public Criteria andCrRateIsNotNull() {
            addCriterion("cr_rate is not null");
            return (Criteria) this;
        }

        public Criteria andCrRateEqualTo(Double value) {
            addCriterion("cr_rate =", value, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateNotEqualTo(Double value) {
            addCriterion("cr_rate <>", value, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateGreaterThan(Double value) {
            addCriterion("cr_rate >", value, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateGreaterThanOrEqualTo(Double value) {
            addCriterion("cr_rate >=", value, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateLessThan(Double value) {
            addCriterion("cr_rate <", value, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateLessThanOrEqualTo(Double value) {
            addCriterion("cr_rate <=", value, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateIn(List<Double> values) {
            addCriterion("cr_rate in", values, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateNotIn(List<Double> values) {
            addCriterion("cr_rate not in", values, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateBetween(Double value1, Double value2) {
            addCriterion("cr_rate between", value1, value2, "crRate");
            return (Criteria) this;
        }

        public Criteria andCrRateNotBetween(Double value1, Double value2) {
            addCriterion("cr_rate not between", value1, value2, "crRate");
            return (Criteria) this;
        }

        public Criteria andMajRateIsNull() {
            addCriterion("maj_rate is null");
            return (Criteria) this;
        }

        public Criteria andMajRateIsNotNull() {
            addCriterion("maj_rate is not null");
            return (Criteria) this;
        }

        public Criteria andMajRateEqualTo(Double value) {
            addCriterion("maj_rate =", value, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateNotEqualTo(Double value) {
            addCriterion("maj_rate <>", value, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateGreaterThan(Double value) {
            addCriterion("maj_rate >", value, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateGreaterThanOrEqualTo(Double value) {
            addCriterion("maj_rate >=", value, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateLessThan(Double value) {
            addCriterion("maj_rate <", value, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateLessThanOrEqualTo(Double value) {
            addCriterion("maj_rate <=", value, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateIn(List<Double> values) {
            addCriterion("maj_rate in", values, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateNotIn(List<Double> values) {
            addCriterion("maj_rate not in", values, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateBetween(Double value1, Double value2) {
            addCriterion("maj_rate between", value1, value2, "majRate");
            return (Criteria) this;
        }

        public Criteria andMajRateNotBetween(Double value1, Double value2) {
            addCriterion("maj_rate not between", value1, value2, "majRate");
            return (Criteria) this;
        }

        public Criteria andMinRateIsNull() {
            addCriterion("min_rate is null");
            return (Criteria) this;
        }

        public Criteria andMinRateIsNotNull() {
            addCriterion("min_rate is not null");
            return (Criteria) this;
        }

        public Criteria andMinRateEqualTo(Double value) {
            addCriterion("min_rate =", value, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateNotEqualTo(Double value) {
            addCriterion("min_rate <>", value, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateGreaterThan(Double value) {
            addCriterion("min_rate >", value, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateGreaterThanOrEqualTo(Double value) {
            addCriterion("min_rate >=", value, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateLessThan(Double value) {
            addCriterion("min_rate <", value, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateLessThanOrEqualTo(Double value) {
            addCriterion("min_rate <=", value, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateIn(List<Double> values) {
            addCriterion("min_rate in", values, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateNotIn(List<Double> values) {
            addCriterion("min_rate not in", values, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateBetween(Double value1, Double value2) {
            addCriterion("min_rate between", value1, value2, "minRate");
            return (Criteria) this;
        }

        public Criteria andMinRateNotBetween(Double value1, Double value2) {
            addCriterion("min_rate not between", value1, value2, "minRate");
            return (Criteria) this;
        }

        public Criteria andCrQuantityIsNull() {
            addCriterion("cr_quantity is null");
            return (Criteria) this;
        }

        public Criteria andCrQuantityIsNotNull() {
            addCriterion("cr_quantity is not null");
            return (Criteria) this;
        }

        public Criteria andCrQuantityEqualTo(Integer value) {
            addCriterion("cr_quantity =", value, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityNotEqualTo(Integer value) {
            addCriterion("cr_quantity <>", value, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityGreaterThan(Integer value) {
            addCriterion("cr_quantity >", value, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("cr_quantity >=", value, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityLessThan(Integer value) {
            addCriterion("cr_quantity <", value, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("cr_quantity <=", value, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityIn(List<Integer> values) {
            addCriterion("cr_quantity in", values, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityNotIn(List<Integer> values) {
            addCriterion("cr_quantity not in", values, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityBetween(Integer value1, Integer value2) {
            addCriterion("cr_quantity between", value1, value2, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andCrQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("cr_quantity not between", value1, value2, "crQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityIsNull() {
            addCriterion("maj_quantity is null");
            return (Criteria) this;
        }

        public Criteria andMajQuantityIsNotNull() {
            addCriterion("maj_quantity is not null");
            return (Criteria) this;
        }

        public Criteria andMajQuantityEqualTo(Integer value) {
            addCriterion("maj_quantity =", value, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityNotEqualTo(Integer value) {
            addCriterion("maj_quantity <>", value, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityGreaterThan(Integer value) {
            addCriterion("maj_quantity >", value, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("maj_quantity >=", value, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityLessThan(Integer value) {
            addCriterion("maj_quantity <", value, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("maj_quantity <=", value, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityIn(List<Integer> values) {
            addCriterion("maj_quantity in", values, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityNotIn(List<Integer> values) {
            addCriterion("maj_quantity not in", values, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityBetween(Integer value1, Integer value2) {
            addCriterion("maj_quantity between", value1, value2, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMajQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("maj_quantity not between", value1, value2, "majQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityIsNull() {
            addCriterion("min_quantity is null");
            return (Criteria) this;
        }

        public Criteria andMinQuantityIsNotNull() {
            addCriterion("min_quantity is not null");
            return (Criteria) this;
        }

        public Criteria andMinQuantityEqualTo(Integer value) {
            addCriterion("min_quantity =", value, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityNotEqualTo(Integer value) {
            addCriterion("min_quantity <>", value, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityGreaterThan(Integer value) {
            addCriterion("min_quantity >", value, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("min_quantity >=", value, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityLessThan(Integer value) {
            addCriterion("min_quantity <", value, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("min_quantity <=", value, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityIn(List<Integer> values) {
            addCriterion("min_quantity in", values, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityNotIn(List<Integer> values) {
            addCriterion("min_quantity not in", values, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityBetween(Integer value1, Integer value2) {
            addCriterion("min_quantity between", value1, value2, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andMinQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("min_quantity not between", value1, value2, "minQuantity");
            return (Criteria) this;
        }

        public Criteria andCheckResultIsNull() {
            addCriterion("check_result is null");
            return (Criteria) this;
        }

        public Criteria andCheckResultIsNotNull() {
            addCriterion("check_result is not null");
            return (Criteria) this;
        }

        public Criteria andCheckResultEqualTo(String value) {
            addCriterion("check_result =", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultNotEqualTo(String value) {
            addCriterion("check_result <>", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultGreaterThan(String value) {
            addCriterion("check_result >", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultGreaterThanOrEqualTo(String value) {
            addCriterion("check_result >=", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultLessThan(String value) {
            addCriterion("check_result <", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultLessThanOrEqualTo(String value) {
            addCriterion("check_result <=", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultLike(String value) {
            addCriterion("check_result like", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultNotLike(String value) {
            addCriterion("check_result not like", value, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultIn(List<String> values) {
            addCriterion("check_result in", values, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultNotIn(List<String> values) {
            addCriterion("check_result not in", values, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultBetween(String value1, String value2) {
            addCriterion("check_result between", value1, value2, "checkResult");
            return (Criteria) this;
        }

        public Criteria andCheckResultNotBetween(String value1, String value2) {
            addCriterion("check_result not between", value1, value2, "checkResult");
            return (Criteria) this;
        }

        public Criteria andReciveDateIsNull() {
            addCriterion("recive_date is null");
            return (Criteria) this;
        }

        public Criteria andReciveDateIsNotNull() {
            addCriterion("recive_date is not null");
            return (Criteria) this;
        }

        public Criteria andReciveDateEqualTo(Date value) {
            addCriterion("recive_date =", value, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateNotEqualTo(Date value) {
            addCriterion("recive_date <>", value, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateGreaterThan(Date value) {
            addCriterion("recive_date >", value, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateGreaterThanOrEqualTo(Date value) {
            addCriterion("recive_date >=", value, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateLessThan(Date value) {
            addCriterion("recive_date <", value, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateLessThanOrEqualTo(Date value) {
            addCriterion("recive_date <=", value, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateIn(List<Date> values) {
            addCriterion("recive_date in", values, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateNotIn(List<Date> values) {
            addCriterion("recive_date not in", values, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateBetween(Date value1, Date value2) {
            addCriterion("recive_date between", value1, value2, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andReciveDateNotBetween(Date value1, Date value2) {
            addCriterion("recive_date not between", value1, value2, "reciveDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateIsNull() {
            addCriterion("inspect_date is null");
            return (Criteria) this;
        }

        public Criteria andInspectDateIsNotNull() {
            addCriterion("inspect_date is not null");
            return (Criteria) this;
        }

        public Criteria andInspectDateEqualTo(Date value) {
            addCriterion("inspect_date =", value, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateNotEqualTo(Date value) {
            addCriterion("inspect_date <>", value, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateGreaterThan(Date value) {
            addCriterion("inspect_date >", value, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateGreaterThanOrEqualTo(Date value) {
            addCriterion("inspect_date >=", value, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateLessThan(Date value) {
            addCriterion("inspect_date <", value, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateLessThanOrEqualTo(Date value) {
            addCriterion("inspect_date <=", value, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateIn(List<Date> values) {
            addCriterion("inspect_date in", values, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateNotIn(List<Date> values) {
            addCriterion("inspect_date not in", values, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateBetween(Date value1, Date value2) {
            addCriterion("inspect_date between", value1, value2, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectDateNotBetween(Date value1, Date value2) {
            addCriterion("inspect_date not between", value1, value2, "inspectDate");
            return (Criteria) this;
        }

        public Criteria andInspectorIsNull() {
            addCriterion("inspector is null");
            return (Criteria) this;
        }

        public Criteria andInspectorIsNotNull() {
            addCriterion("inspector is not null");
            return (Criteria) this;
        }

        public Criteria andInspectorEqualTo(String value) {
            addCriterion("inspector =", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorNotEqualTo(String value) {
            addCriterion("inspector <>", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorGreaterThan(String value) {
            addCriterion("inspector >", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorGreaterThanOrEqualTo(String value) {
            addCriterion("inspector >=", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorLessThan(String value) {
            addCriterion("inspector <", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorLessThanOrEqualTo(String value) {
            addCriterion("inspector <=", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorLike(String value) {
            addCriterion("inspector like", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorNotLike(String value) {
            addCriterion("inspector not like", value, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorIn(List<String> values) {
            addCriterion("inspector in", values, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorNotIn(List<String> values) {
            addCriterion("inspector not in", values, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorBetween(String value1, String value2) {
            addCriterion("inspector between", value1, value2, "inspector");
            return (Criteria) this;
        }

        public Criteria andInspectorNotBetween(String value1, String value2) {
            addCriterion("inspector not between", value1, value2, "inspector");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andAttr1IsNull() {
            addCriterion("attr1 is null");
            return (Criteria) this;
        }

        public Criteria andAttr1IsNotNull() {
            addCriterion("attr1 is not null");
            return (Criteria) this;
        }

        public Criteria andAttr1EqualTo(String value) {
            addCriterion("attr1 =", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1NotEqualTo(String value) {
            addCriterion("attr1 <>", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1GreaterThan(String value) {
            addCriterion("attr1 >", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1GreaterThanOrEqualTo(String value) {
            addCriterion("attr1 >=", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1LessThan(String value) {
            addCriterion("attr1 <", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1LessThanOrEqualTo(String value) {
            addCriterion("attr1 <=", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1Like(String value) {
            addCriterion("attr1 like", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1NotLike(String value) {
            addCriterion("attr1 not like", value, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1In(List<String> values) {
            addCriterion("attr1 in", values, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1NotIn(List<String> values) {
            addCriterion("attr1 not in", values, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1Between(String value1, String value2) {
            addCriterion("attr1 between", value1, value2, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr1NotBetween(String value1, String value2) {
            addCriterion("attr1 not between", value1, value2, "attr1");
            return (Criteria) this;
        }

        public Criteria andAttr2IsNull() {
            addCriterion("attr2 is null");
            return (Criteria) this;
        }

        public Criteria andAttr2IsNotNull() {
            addCriterion("attr2 is not null");
            return (Criteria) this;
        }

        public Criteria andAttr2EqualTo(String value) {
            addCriterion("attr2 =", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2NotEqualTo(String value) {
            addCriterion("attr2 <>", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2GreaterThan(String value) {
            addCriterion("attr2 >", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2GreaterThanOrEqualTo(String value) {
            addCriterion("attr2 >=", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2LessThan(String value) {
            addCriterion("attr2 <", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2LessThanOrEqualTo(String value) {
            addCriterion("attr2 <=", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2Like(String value) {
            addCriterion("attr2 like", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2NotLike(String value) {
            addCriterion("attr2 not like", value, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2In(List<String> values) {
            addCriterion("attr2 in", values, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2NotIn(List<String> values) {
            addCriterion("attr2 not in", values, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2Between(String value1, String value2) {
            addCriterion("attr2 between", value1, value2, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr2NotBetween(String value1, String value2) {
            addCriterion("attr2 not between", value1, value2, "attr2");
            return (Criteria) this;
        }

        public Criteria andAttr3IsNull() {
            addCriterion("attr3 is null");
            return (Criteria) this;
        }

        public Criteria andAttr3IsNotNull() {
            addCriterion("attr3 is not null");
            return (Criteria) this;
        }

        public Criteria andAttr3EqualTo(Integer value) {
            addCriterion("attr3 =", value, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3NotEqualTo(Integer value) {
            addCriterion("attr3 <>", value, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3GreaterThan(Integer value) {
            addCriterion("attr3 >", value, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3GreaterThanOrEqualTo(Integer value) {
            addCriterion("attr3 >=", value, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3LessThan(Integer value) {
            addCriterion("attr3 <", value, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3LessThanOrEqualTo(Integer value) {
            addCriterion("attr3 <=", value, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3In(List<Integer> values) {
            addCriterion("attr3 in", values, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3NotIn(List<Integer> values) {
            addCriterion("attr3 not in", values, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3Between(Integer value1, Integer value2) {
            addCriterion("attr3 between", value1, value2, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr3NotBetween(Integer value1, Integer value2) {
            addCriterion("attr3 not between", value1, value2, "attr3");
            return (Criteria) this;
        }

        public Criteria andAttr4IsNull() {
            addCriterion("attr4 is null");
            return (Criteria) this;
        }

        public Criteria andAttr4IsNotNull() {
            addCriterion("attr4 is not null");
            return (Criteria) this;
        }

        public Criteria andAttr4EqualTo(Integer value) {
            addCriterion("attr4 =", value, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4NotEqualTo(Integer value) {
            addCriterion("attr4 <>", value, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4GreaterThan(Integer value) {
            addCriterion("attr4 >", value, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4GreaterThanOrEqualTo(Integer value) {
            addCriterion("attr4 >=", value, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4LessThan(Integer value) {
            addCriterion("attr4 <", value, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4LessThanOrEqualTo(Integer value) {
            addCriterion("attr4 <=", value, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4In(List<Integer> values) {
            addCriterion("attr4 in", values, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4NotIn(List<Integer> values) {
            addCriterion("attr4 not in", values, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4Between(Integer value1, Integer value2) {
            addCriterion("attr4 between", value1, value2, "attr4");
            return (Criteria) this;
        }

        public Criteria andAttr4NotBetween(Integer value1, Integer value2) {
            addCriterion("attr4 not between", value1, value2, "attr4");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("create_by is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("create_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(String value) {
            addCriterion("create_by =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(String value) {
            addCriterion("create_by <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(String value) {
            addCriterion("create_by >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(String value) {
            addCriterion("create_by >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(String value) {
            addCriterion("create_by <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(String value) {
            addCriterion("create_by <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLike(String value) {
            addCriterion("create_by like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotLike(String value) {
            addCriterion("create_by not like", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<String> values) {
            addCriterion("create_by in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<String> values) {
            addCriterion("create_by not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(String value1, String value2) {
            addCriterion("create_by between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(String value1, String value2) {
            addCriterion("create_by not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("update_by is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("update_by is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(String value) {
            addCriterion("update_by =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(String value) {
            addCriterion("update_by <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(String value) {
            addCriterion("update_by >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(String value) {
            addCriterion("update_by >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(String value) {
            addCriterion("update_by <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(String value) {
            addCriterion("update_by <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLike(String value) {
            addCriterion("update_by like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotLike(String value) {
            addCriterion("update_by not like", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<String> values) {
            addCriterion("update_by in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<String> values) {
            addCriterion("update_by not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(String value1, String value2) {
            addCriterion("update_by between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(String value1, String value2) {
            addCriterion("update_by not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}